﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.CharmManager.Server.DAL
{
    public class ServiceItemDAL_Const
    {
        public static readonly string SQL_INSERT_SERVICEITEM = @"INSERT INTO SERVICEITEM(
            SNAME, SCATEGORYID, SPRICE, STIMESPAN, STATE, SCALLBACKFLAG,
            SCALLBACKDAY, STARTDATE, SENDDATE, SREMARK, SAVAILABLEDAYS, 
            SINDEXCODE, SERVICEITEMCODE, SCOUNT) VALUES (
            @SNAME, @SCATEGORYID, @SPRICE, @STIMESPAN, @STATE, @SCALLBACKFLAG,
            @SCALLBACKDAY, @STARTDATE, @SENDDATE, @SREMARK, @SAVAILABLEDAYS, 
            @SINDEXCODE, @SERVICEITEMCODE, @SCOUNT)";

        public static readonly string SQL_UPDATE_SERVICEITEM = @"UPDATE SERVICEITEM SET SNAME=@SNAME,
            SCATEGORYID=@SCATEGORYID, SPRICE=@SPRICE, STIMESPAN=@STIMESPAN, STATE=@STATE, 
            SCALLBACKFLAG=@SCALLBACKFLAG, SCALLBACKDAY=@SCALLBACKDAY, STARTDATE=@STARTDATE,
            SENDDATE=@SENDDATE, SREMARK=@SREMARK, SAVAILABLEDAYS=@SAVAILABLEDAYS, 
            SINDEXCODE=@SINDEXCODE, SERVICEITEMCODE=@SERVICEITEMCODE, SCOUNT=@SCOUNT WHERE SERVICEITEMID=@SERVICEITEMID";

        public static readonly string SQL_UPDATE_SETSTATE_SERVICEITEM = @"UPDATE SERVICEITEM SET STATE=@STATE WHERE SERVICEITEMID=@SERVICEITEMID";

        public static readonly string SQL_UPDATE_RESET_SERVICEITEM_CATEGORY = "UPDATE SERVICEITEM SET SCATEGORYID=@NEWSCATEGORYID WHERE SCATEGORYID=@SCATEGORYID";

        public static readonly string SQL_SELECT_SERVICEITEM = "SELECT * FROM SERVICEITEM";

        public static readonly string SQL_SELECT_SERVICEITEM_AVAILABLEDAY = "SELECT SAVAILABLEDAYS FROM SERVICEITEM WHERE SERVICEITEMID = @SERVICEITEMID";
    }
}
